/*
 * Copyright (c) 2023 OceanBase.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.oceanbase.odc.core.sql.execute.mapper;

import java.sql.SQLException;
import java.sql.Timestamp;
import java.time.ZoneId;
import java.time.ZonedDateTime;
import java.time.format.DateTimeFormatter;

import lombok.NonNull;

public class OracleGeneralTimestampMapper extends MySQLTimestampMapper {
    @Override
    public Object mapCell(@NonNull CellData data) throws SQLException {
        Timestamp timestamp = data.getTimestamp();
        if (timestamp == null) {
            return null;
        }
        DateTimeFormatter formatter = DateTimeFormatter.ISO_OFFSET_DATE_TIME;
        if (!isValidTimestamp(data)) {
            return formatter.format(ZonedDateTime.of(0, 0, 0, 0, 0, 0, 0, ZoneId.systemDefault()));
        }
        return formatter.format(ZonedDateTime.ofInstant(timestamp.toInstant(), ZoneId.systemDefault()));
    }
}
